set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go









-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[procCategories_getRootsType] 
	-- Add the parameters for the stored procedure here	
@Type as nvarchar(50)
AS
BEGIN
	select 	ID,
	[Name],
	NameVN,
	Rank,
	LinkedID,
	[Level],
	Status,
	Type,
	[Image],
	Decribes
 from  dbo.[Categories]
where [Level]=1 and Type = @Type
order by Rank ASC
END










